Skip to main content

YEARFRAC

Returns the fraction of the year represented by the number of whole days between two dates

Syntax​

YEARFRAC(StartDate, EndDate, Basis)

Arguments​

  • StartDate: A date that represents the start date.
  • EndDate: A date that represents the end date.
  • Basis : Optional, the type of day count basis to use

Example​

YEAR('1/1/2012', '7/30/2012') → Returns 0.58055